﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.OracleClient;
using Maticsoft.DBUtility;

namespace Xiaov.SmartWeb.Application.Excel
{
  public class CODE_BBBMB
  {
    public CODE_BBBMB()
    { }
    #region Model
    private string _bbbm;
    private string _bbmc;
    private string _bbwh;
    private string _bbzq;
    private string _yqsbsj;
    private string _bblx;
    private string _dqzt;
    private decimal _pxxh;
    private string _cgzzsx;
    private decimal? _ls;
    private string _plfx;
    private decimal? _rowcount;
    private decimal? _columncount;
    private string _caption;
    private string _coordinates;
    /// <summary>
    /// 
    /// </summary>
    public string BBBM
    {
      set { _bbbm = value; }
      get { return _bbbm; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string BBMC
    {
      set { _bbmc = value; }
      get { return _bbmc; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string BBWH
    {
      set { _bbwh = value; }
      get { return _bbwh; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string BBZQ
    {
      set { _bbzq = value; }
      get { return _bbzq; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string YQSBSJ
    {
      set { _yqsbsj = value; }
      get { return _yqsbsj; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string BBLX
    {
      set { _bblx = value; }
      get { return _bblx; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string DQZT
    {
      set { _dqzt = value; }
      get { return _dqzt; }
    }
    /// <summary>
    /// 
    /// </summary>
    public decimal PXXH
    {
      set { _pxxh = value; }
      get { return _pxxh; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string CGZZSX
    {
      set { _cgzzsx = value; }
      get { return _cgzzsx; }
    }
    /// <summary>
    /// 
    /// </summary>
    public decimal? LS
    {
      set { _ls = value; }
      get { return _ls; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string PLFX
    {
      set { _plfx = value; }
      get { return _plfx; }
    }
    /// <summary>
    /// 
    /// </summary>
    public decimal? ROWCOUNT
    {
      set { _rowcount = value; }
      get { return _rowcount; }
    }
    /// <summary>
    /// 
    /// </summary>
    public decimal? COLUMNCOUNT
    {
      set { _columncount = value; }
      get { return _columncount; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string CAPTION
    {
      set { _caption = value; }
      get { return _caption; }
    }
    /// <summary>
    /// 
    /// </summary>
    public string COORDINATES
    {
      set { _coordinates = value; }
      get { return _coordinates; }
    }
    #endregion Model
    public CODE_BBBMB(string bbbm)
    {
      string sql = "select * from CODE_BBBMB where bbbm=:0";
      OracleParameter[] parms = { new OracleParameter(":0", OracleType.VarChar, 10) };
      parms[0].Value = bbbm;
      OracleDataReader dr = DbHelperOra.ExecuteReader(sql, parms);
      if (dr.Read())
      {
        COORDINATES = dr["COORDINATES"].ToString();
      }
      dr.Close();
    }
  }
}